/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package DBFunction;

import java.sql.ResultSet;
import java.sql.SQLException;



public class fCheckInactive {
	public static String process(String currentPhoneNumber)		{

		String rs= "1";
		// get buddies of person form same group
		String sql = "SELECT GroupId from buddytracking.user where PhoneNumber = '"
				+ currentPhoneNumber + "'";
		ResultSet resultSet = DB.connectDB.ExecuteQuery(sql);

		try {
			while (resultSet.next()) {				
				 if (resultSet.getString("GroupId").equals("0"))
				 rs = "2";				 
			}
		} catch (SQLException ex) {
		}
		return rs;
	}
}
